Map Not Exportable

Note  XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003.

The contents of an XML mapping cannot be exported under the following circumstances:

• An XML mapping cannot be exported if the mapped element’s relationship with other elements cannot be preserved. This relationship may not be preserved for the following reasons:
  • The schema definition of a mapped element is contained within a sequence with the following attributes:
    • The maxoccurs attribute is not equal to 1.
    • The sequence has more than one direct child element defined, or has another compositor as a direct child.
  • Non-repeating sibling elements with the same repeating parent element are mapped to different XML lists.
  • Multiple repeating elements are mapped to the same XML list, and the repetition not defined by an ancestor element.
  • Child elements from different parents are mapped to the same XML list.
• The XML mapping contains one of the following XML schema constructs:
  • List of lists    One list of items contains a second list of items.
  • Denormalized data    An XML list contains an element that has been defined in the schema to occur once (the maxoccurs attribute is set to 1). When you add such an element to an XML list, Excel fills the list column with multiple instances of the element.
  • Choice    This is a mapped element that is part of a <choice> schema construct.